﻿-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		08/21/2010 1.0
-- ==========================================================================================================
CREATE PROCEDURE [flcr].[api_service_dml_ins]
	@SERVICE_ID INT = NULL OUTPUT
	,@AUDIT_USER VARCHAR(100)
	,@AUDIT_DTTM DATETIME
	,@AUDIT_DTTM_TZ INT
	,@AUDIT_MOD_USER VARCHAR(100)
	,@AUDIT_MOD_DTTM DATETIME 
	,@AUDIT_MOD_DTTM_TZ INT 
	,@RLS_MASK VARBINARY(256)
	,@RLS_OWNER UNIQUEIDENTIFIER
	,@BUILTIN BIT
	,@WRKFL_ITEM_ID INT
	,@WRKFL_STATUS_ID INT
	,@ACTIVE_FLG BIT
	,@SORT_ORDER INT
	,@SERVICE_NAME VARCHAR(100)
	,@SERVICE_SNAME VARCHAR(50)
	,@SERVICE_DESC VARCHAR(MAX)
	,@SERVICE_TYPE INT
	,@PARENT_ID INT
	,@DOMAIN_ID INT
	,@ORG_ID INT
	,@RESOURCE_ID INT
	,@SUPPLIER_ID INT
	,@SLA_ID INT

AS
BEGIN TRY

	INSERT INTO [flcr].[SERVICE]
           ([AUDIT_USER]
           ,[AUDIT_DTTM]
           ,[AUDIT_DTTM_TZ] 
           ,[AUDIT_MOD_USER]
           ,[AUDIT_MOD_DTTM]
           ,[AUDIT_MOD_DTTM_TZ] 
           ,[RLS_MASK]
           ,[RLS_OWNER]
           ,[BUILTIN]
           ,[WRKFL_ITEM_ID]
           ,[WRKFL_STATUS_ID]
           ,[ACTIVE_FLG]
           ,[SORT_ORDER]
           ,[SERVICE_NAME]
           ,[SERVICE_SNAME]
           ,[SERVICE_DESC]
           ,[SERVICE_TYPE]
           ,[PARENT_ID]
           ,[DOMAIN_ID]
           ,[ORG_ID]
           ,[RESOURCE_ID]
           ,[SUPPLIER_ID]
           ,[SLA_ID])
     VALUES
           (@AUDIT_USER
           ,@AUDIT_DTTM
           ,@AUDIT_DTTM_TZ
           ,@AUDIT_USER
           ,@AUDIT_DTTM
           ,@AUDIT_DTTM_TZ
           ,@RLS_MASK
           ,@RLS_OWNER
           ,@BUILTIN
           ,@WRKFL_ITEM_ID
           ,@WRKFL_STATUS_ID
           ,@ACTIVE_FLG
           ,@SORT_ORDER
           ,@SERVICE_NAME
           ,@SERVICE_SNAME
           ,@SERVICE_DESC
           ,@SERVICE_TYPE
           ,@PARENT_ID
           ,@DOMAIN_ID
           ,@ORG_ID
           ,@RESOURCE_ID
           ,@SUPPLIER_ID
           ,@SLA_ID)
 
		SELECT @SERVICE_ID = SCOPE_IDENTITY()

END TRY
BEGIN CATCH
	EXEC [flcr].[utl_getDBError];
END CATCH